//package com.ptu.spzx.user.mapper;
//
//import com.baomidou.mybatisplus.core.mapper.BaseMapper;
//import com.ptu.spzx.model.entity.system.SysUser;
//import com.ptu.spzx.model.entity.user.UserInfo;
//import org.apache.ibatis.annotations.Mapper;
//import org.apache.ibatis.annotations.Param;
//import org.apache.ibatis.annotations.Select;
//import org.apache.ibatis.annotations.Update;
//
//import java.util.List;
//import java.util.Map;
//
//@Mapper
//public interface SysUserMapper extends BaseMapper<SysUser> {
//    @Select("SELECT * FROM sys_user WHERE user_name=#{userName}")
//    SysUser selectByUsername(String username);
//
//    @Update(" update sys_user set class_name=#{className} where stu_id = #{stuId}")
//    void setClassId(String stuId, String className);
//
//    @Select("SELECT * FROM sys_user WHERE stu_id=#{stuId}")
//    SysUser getStu(String stuId);
//
//    @Select("SELECT * FROM sys_user WHERE class_name=#{className}}")
//    List<SysUser> getStus(String className);
//
//    @Update("update user_info set department=#{department},speciality=#{speciality} where stu_id=#{stuId}")
//    Integer doAssign(Map<String, Object> params);
//
//    @Select("SELECT stu_id FROM sys_user WHERE class_name=#{className} AND is_deleted=0")
//     List<String> getStuListByClass(@Param("className") String className);
//
//    @Update("UPDATE sys_user set class_name=null where class_name=#{className}")
//    Integer setClaaNull(String className);
//
//    @Select("SELECT * FROM sys_user WHERE class_name=#{className} AND is_deleted=0")
//    List<UserInfo> getStuListByClassName(@Param("className") String className);
//
//    @Select("SELECT * FROM sys_user WHERE stu_id=#{stuId} AND is_deleted=0")
//    List<SysUser> getStuListByStuId(String stuId);
//}
